using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace LHS.Core.TableInfo
{
    public class InfoMedicineExport
    {
        public const string MEXISN = "mexISN";
        public const string CLRISN = "clrISN";
        public const string MESISN = "mesISN";
        public const string MEXMEDICINENAME = "mexMedicineName";
        public const string MEXMEDICEORDERSOURCE = "mexMediceOrderSource";
        public const string MEXUSAGE = "mexUsage";
        public const string MEXQUANTITYPERUNIT = "mexQuantityPerUnit";
        public const string MEXPRODUCTIONPERUNIT = "mexProductionPerUnit";
        public const string MEXDATEEXPORT = "mexDateExport";
        public const string MEXTAKEPERDAY = "mexTakePerDay";
        public const string MEXQUANTITYPERDAY = "mexQuantityPerDay";
        public const string MEXUSAGEPERDAY = "mexUsagePerDay";
        public const string MEXUSAGEUNIT = "mexUsageUnit";
        public const string MEXNOTE = "mexNote";
        public const string MEXORDER = "mexOrder";
        public const string MEXSTATUS = "mexStatus";

        //phan moi them
        public const string MEXTOTALQUANTITY = "mexTotalQuantity";
        public const string MEXTOTALUSAGEDAY = "mexTotalUsageDay";
        //end phan moi them

        public const string TABLENAME = "MedicineExport";

        public static DataTable GetStructure()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(MEXISN, typeof(int));
            dt.Columns.Add(CLRISN, typeof(int));
            dt.Columns.Add(MESISN, typeof(int));
            dt.Columns.Add(MEXMEDICINENAME, typeof(string));
            dt.Columns.Add(MEXMEDICEORDERSOURCE, typeof(string));
            dt.Columns.Add(MEXUSAGE, typeof(string));
            dt.Columns.Add(MEXQUANTITYPERUNIT, typeof(int));
            dt.Columns.Add(MEXPRODUCTIONPERUNIT, typeof(int));
            dt.Columns.Add(MEXDATEEXPORT, typeof(DateTime ));
            dt.Columns.Add(MEXTAKEPERDAY, typeof(int));
            dt.Columns.Add(MEXQUANTITYPERDAY, typeof(string));
            dt.Columns.Add(MEXUSAGEPERDAY, typeof(string));
            dt.Columns.Add(MEXUSAGEUNIT, typeof(string));
            dt.Columns.Add(MEXNOTE, typeof(string));
            dt.Columns.Add(MEXORDER, typeof(int));
            dt.Columns.Add(MEXSTATUS, typeof(int));
            
            //phan moi them
            dt.Columns.Add(MEXTOTALQUANTITY, typeof(int));
            dt.Columns.Add(MEXTOTALUSAGEDAY, typeof(int));
            //end phan moi them

            dt.TableName = TABLENAME;
            return dt;
        }

    }
}
